/*
 * Copyright (c) 2007-2021 西安交通信息投资营运有限公司 版权所有
 */

package com.xci.xajtfb.wxc.dao;

import com.github.lvyanyang.annotation.Paging;
import com.xci.xajtfb.wxc.entity.SchCoach;
import com.xci.xajtfb.wxc.filter.SchCoachFilter;
import org.apache.ibatis.annotations.Param;

import java.util.List;

/**
 * 教练员基本资料表数据层
 * @author 马星俊 maxingjun@xci96716.com
 * @since 2021-03-01 17:39:46
 */
public interface SchCoachDao {

    /**
     * 根据主键查询单个教练员基本资料表
     * @param id 教练员基本资料表主键
     * @return 返回教练员基本资料表实体
     */
    SchCoach selectById(@Param("id") Long id);


    /**
     * 查询教练员基本资料表分页列表
     * @param filter 过滤条件
     * @return 返回教练员基本资料表分页列表
     */
    /*
        allowSortNames = {"quasi_teach_number","name","name_spell","sex","id_type","id_number","area_name","area_code","quasi_teach_category","quasi_teach_type_code","quasi_teach_type_name","quasi_drive_enddate","quasi_drive_startdate","school_id","education","coach_zhicheng","certification_dept","driver_license_number","driver_license_startdate","driver_license_enddate","remark","family_address","tel","quasi_drive_type","status","signing_startdate","signing_enddate","birth_date","audit_status","audit_date","audit_name","coach_url","audit_opinion","input_sources","isblacklist","work_post","is_coach","old_strid","create_user_id","create_user_name","create_date_time","update_user_id","update_user_name","update_date_time"},
        sortNameMaps = {"quasi_teach_number:quasi_teach_number","name:name","name_spell:name_spell","sex:sex","id_type:id_type","id_number:id_number","area_name:area_name","area_code:area_code","quasi_teach_category:quasi_teach_category","quasi_teach_type_code:quasi_teach_type_code","quasi_teach_type_name:quasi_teach_type_name","quasi_drive_enddate:quasi_drive_enddate","quasi_drive_startdate:quasi_drive_startdate","school_id:school_id","education:education","coach_zhicheng:coach_zhicheng","certification_dept:certification_dept","driver_license_number:driver_license_number","driver_license_startdate:driver_license_startdate","driver_license_enddate:driver_license_enddate","remark:remark","family_address:family_address","tel:tel","quasi_drive_type:quasi_drive_type","status:status","signing_startdate:signing_startdate","signing_enddate:signing_enddate","birth_date:birth_date","audit_status:audit_status","audit_date:audit_date","audit_name:audit_name","coach_url:coach_url","audit_opinion:audit_opinion","input_sources:input_sources","isblacklist:isblacklist","work_post:work_post","is_coach:is_coach","old_strid:old_strid","create_user_id:create_user_id","create_user_name:create_user_name","create_date_time:create_date_time","update_user_id:update_user_id","update_user_name:update_user_name","update_date_time:update_date_time"}
    */
    @Paging
    List<SchCoach> selectPageList(@Param("filter") SchCoachFilter filter);
}